<!DOCTYPE html>
<html lang="en-US">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width,initial-scale=1">
    <title>Sheet Configuration | Luckysheet Document</title>
    <meta name="generator" content="VuePress 1.7.1">
    
    <meta name="description" content="Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.This site contains official configuration document, API, and tutorial.">
    <meta property="article:modified_time" content="2020-12-17T08:23:07.000Z">
    <meta property="og:title" content="Sheet Configuration">
    <meta property="og:type" content="article">
    <meta property="og:url" content="https://mengshukeji.github.io/LuckysheetDemo/guide/sheet.html">
    <meta name="twitter:title" content="Sheet Configuration">
    <meta name="twitter:url" content="https://mengshukeji.github.io/LuckysheetDemo/guide/sheet.html">
    <meta name="twitter:card" content="summary_large_image">
    <meta name="twitter:label1" content="Written by">
    
    <link rel="preload" href="/LuckysheetDocs/assets/css/0.styles.48756c9a.css" as="style"><link rel="preload" href="/LuckysheetDocs/assets/js/app.fd749708.js" as="script"><link rel="preload" href="/LuckysheetDocs/assets/js/2.08ae9631.js" as="script"><link rel="preload" href="/LuckysheetDocs/assets/js/20.085877c0.js" as="script"><link rel="prefetch" href="/LuckysheetDocs/assets/js/10.5aa5c910.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/11.b5f38301.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/12.ba6e3444.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/13.facb0d4d.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/14.5329ef33.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/15.b16af5b8.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/16.3ab9af64.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/17.89342c1c.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/18.4117a1ba.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/19.b7bced65.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/21.7942a443.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/22.71c06ffc.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/23.7e0bb3f7.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/24.b3632420.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/25.af0769a6.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/26.003d03b5.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/27.d66536ec.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/28.4c5a65e7.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/29.cde76ea7.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/3.5220f451.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/30.431c8d21.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/31.b1bc10b5.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/32.0303e169.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/33.2fdafa57.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/4.17e14ac8.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/5.d496610c.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/6.edd4669e.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/7.9a67dd07.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/8.4431336c.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/9.d6068f70.js">
    <link rel="stylesheet" href="/LuckysheetDocs/assets/css/0.styles.48756c9a.css">
  </head>
  <body>
    <div id="app" data-server-rendered="true"><div class="theme-container"><header class="navbar"><div class="sidebar-button"><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" role="img" viewBox="0 0 448 512" class="icon"><path fill="currentColor" d="M436 124H12c-6.627 0-12-5.373-12-12V80c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12z"></path></svg></div> <a href="/LuckysheetDocs/" class="home-link router-link-active"><img src="/LuckysheetDocs/img/logo.png" alt="Luckysheet Document" class="logo"> <span class="site-name can-hide">Luckysheet Document</span></a> <div class="links"><div class="search-box"><input aria-label="Search" autocomplete="off" spellcheck="false" value=""> <!----></div> <nav class="nav-links can-hide"><div class="nav-item"><a href="/LuckysheetDocs/" class="nav-link">
  Home
</a></div><div class="nav-item"><a href="/LuckysheetDocs/guide/" class="nav-link router-link-active">
  Guide
</a></div><div class="nav-item"><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Demo
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="More" class="dropdown-title"><span class="title">More</span> <span class="arrow down"></span></button> <button type="button" aria-label="More" class="mobile-dropdown-title"><span class="title">More</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/about/" class="nav-link">
  About
</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="Select language" class="dropdown-title"><span class="title">Languages</span> <span class="arrow down"></span></button> <button type="button" aria-label="Select language" class="mobile-dropdown-title"><span class="title">Languages</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/guide/sheet.html" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  English
</a></li><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/guide/sheet.html" class="nav-link">
  简体中文
</a></li></ul></div></div> <a href="https://github.com/mengshukeji/Luckysheet" target="_blank" rel="noopener noreferrer" class="repo-link">
    GitHub
    <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav></div></header> <div class="sidebar-mask"></div> <aside class="sidebar"><nav class="nav-links"><div class="nav-item"><a href="/LuckysheetDocs/" class="nav-link">
  Home
</a></div><div class="nav-item"><a href="/LuckysheetDocs/guide/" class="nav-link router-link-active">
  Guide
</a></div><div class="nav-item"><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Demo
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="More" class="dropdown-title"><span class="title">More</span> <span class="arrow down"></span></button> <button type="button" aria-label="More" class="mobile-dropdown-title"><span class="title">More</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/about/" class="nav-link">
  About
</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="Select language" class="dropdown-title"><span class="title">Languages</span> <span class="arrow down"></span></button> <button type="button" aria-label="Select language" class="mobile-dropdown-title"><span class="title">Languages</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/guide/sheet.html" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  English
</a></li><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/guide/sheet.html" class="nav-link">
  简体中文
</a></li></ul></div></div> <a href="https://github.com/mengshukeji/Luckysheet" target="_blank" rel="noopener noreferrer" class="repo-link">
    GitHub
    <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav>  <ul class="sidebar-links"><li><a href="/LuckysheetDocs/guide/" aria-current="page" class="sidebar-link">Get started</a></li><li><a href="/LuckysheetDocs/guide/config.html" class="sidebar-link">Overall configuration</a></li><li><a href="/LuckysheetDocs/guide/sheet.html" aria-current="page" class="active sidebar-link">Sheet Configuration</a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header"><a href="/LuckysheetDocs/guide/sheet.html#initial" class="sidebar-link">Initial</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/guide/sheet.html#debug-information" class="sidebar-link">debug information</a></li></ul></li><li><a href="/LuckysheetDocs/guide/cell.html" class="sidebar-link">Format attributes</a></li><li><a href="/LuckysheetDocs/guide/operate.html" class="sidebar-link">Table Operation</a></li><li><a href="/LuckysheetDocs/guide/api.html" class="sidebar-link">API</a></li><li><a href="/LuckysheetDocs/guide/resource.html" class="sidebar-link">Tutorials and resources</a></li><li><a href="/LuckysheetDocs/guide/FAQ.html" class="sidebar-link">FAQ</a></li><li><a href="/LuckysheetDocs/guide/contribute.html" class="sidebar-link">Contribution guide</a></li></ul> </aside> <main class="page"> <div class="theme-default-content content__default"><h1 id="sheet-configuration"><a href="#sheet-configuration" class="header-anchor">#</a> Sheet Configuration</h1> <h2 id="initial"><a href="#initial" class="header-anchor">#</a> Initial</h2> <p>if you want to initial the <code>options</code>, you need to arrange every sheet data to <code>options.data</code></p> <blockquote><p>when the initialization is done, you can use <a href="/LuckysheetDocs/zh/guide/api.html#getAllSheets([setting])"><code>luckysheet.getAllSheets()</code></a> to get all working sheet configurations.</p></blockquote> <p>eg: options.data：</p> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">[</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Cell&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet name</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet color</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet index</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet active status</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//The order of the worksheet</span>
        <span class="token property">&quot;hide&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span><span class="token comment">//Whether worksheet hide </span>
        <span class="token property">&quot;row&quot;</span><span class="token operator">:</span> <span class="token number">36</span><span class="token punctuation">,</span> <span class="token comment">//the number of rows in a sheet</span>
        <span class="token property">&quot;column&quot;</span><span class="token operator">:</span> <span class="token number">18</span><span class="token punctuation">,</span> <span class="token comment">//the number of columns in a sheet</span>
        <span class="token property">&quot;defaultRowHeight&quot;</span><span class="token operator">:</span> <span class="token number">19</span><span class="token punctuation">,</span> <span class="token comment">//Customized default row height</span>
        <span class="token property">&quot;defaultColWidth&quot;</span><span class="token operator">:</span> <span class="token number">73</span><span class="token punctuation">,</span> <span class="token comment">//Customized default column width</span>
        <span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Initial the cell data</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token property">&quot;merge&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//merged cells</span>
            <span class="token property">&quot;rowlen&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Table row height</span>
            <span class="token property">&quot;columnlen&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Table column width</span>
            <span class="token property">&quot;rowhidden&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//hidden rows</span>
            <span class="token property">&quot;colhidden&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//hidden columns</span>
            <span class="token property">&quot;borderInfo&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//borders</span>
            <span class="token property">&quot;authority&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet protection</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token property">&quot;scrollLeft&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//Left and right scroll bar position</span>
        <span class="token property">&quot;scrollTop&quot;</span><span class="token operator">:</span> <span class="token number">315</span><span class="token punctuation">,</span> <span class="token comment">//Up and down scroll bar position</span>
        <span class="token property">&quot;luckysheet_select_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//selected area</span>
        <span class="token property">&quot;calcChain&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span><span class="token comment">//Formula chain</span>
        <span class="token property">&quot;isPivotTable&quot;</span><span class="token operator">:</span><span class="token boolean">false</span><span class="token punctuation">,</span><span class="token comment">//Whether is pivot table</span>
        <span class="token property">&quot;pivotTable&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//Pivot table settings</span>
        <span class="token property">&quot;filter_select&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//Filter range</span>
        <span class="token property">&quot;filter&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span><span class="token comment">//Filter configuration</span>
        <span class="token property">&quot;luckysheet_alternateformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Alternate colors</span>
        <span class="token property">&quot;luckysheet_alternateformat_save_modelCustom&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Customize alternate colors	</span>
        <span class="token property">&quot;luckysheet_conditionformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//condition format</span>
        <span class="token property">&quot;frozen&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//freeze row and column configuration</span>
        <span class="token property">&quot;chart&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Chart configuration</span>
        <span class="token property">&quot;zoomRatio&quot;</span><span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">// zoom ratio</span>
        <span class="token property">&quot;image&quot;</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//image</span>
        <span class="token property">&quot;showGridLines&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Whether to show grid lines</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sheet2&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sheet3&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">]</span>
</code></pre></div><h3 id="name"><a href="#name" class="header-anchor">#</a> name</h3> <ul><li>type：String</li> <li>default：&quot;Sheet1&quot;</li> <li>usage：the name of a sheet</li></ul> <hr> <h3 id="color"><a href="#color" class="header-anchor">#</a> color</h3> <ul><li>type：String</li> <li>default：&quot;##f20e0e&quot;</li> <li>usage：Sheet color, with a bottom border below the sheet name</li></ul> <hr> <h3 id="index"><a href="#index" class="header-anchor">#</a> index</h3> <ul><li>type：String</li> <li>default：&quot;&quot;</li> <li>usage：The worksheet index is used as a unique key value, and a random string is automatically assigned when a worksheet is added. Note that <code>index</code> is not the order of worksheets, and is distinguished from <code>order</code>.</li></ul> <hr> <h3 id="status"><a href="#status" class="header-anchor">#</a> status</h3> <ul><li>type：Number</li> <li>default：1</li> <li>usage：Active state, there is only one active worksheet which number will be 1 and the other worksheets are 0</li></ul> <hr> <h3 id="order"><a href="#order" class="header-anchor">#</a> order</h3> <ul><li>type：Number</li> <li>default：0</li> <li>usage：The subscript of the worksheet represents the order in which the worksheet is displayed in the sheet bar at the bottom. It will increase when a worksheet is added, starting from 0</li></ul> <hr> <h3 id="hide"><a href="#hide" class="header-anchor">#</a> hide</h3> <ul><li>type：Number</li> <li>default：0</li> <li>usage： is the sheet is hidden. <code>0</code> means not to hide, <code>1</code> means hide</li></ul> <hr> <h3 id="row"><a href="#row" class="header-anchor">#</a> row</h3> <ul><li>type：Number</li> <li>default：36</li> <li>usage： Number of cell rows</li></ul> <hr> <h3 id="column"><a href="#column" class="header-anchor">#</a> column</h3> <ul><li>type：Number</li> <li>default：18</li> <li>usage： Number of cell columns</li></ul> <hr> <h3 id="defaultrowheight"><a href="#defaultrowheight" class="header-anchor">#</a> defaultRowHeight</h3> <ul><li>type：Number</li> <li>default：19</li> <li>usage： Customized default row height, unit is px</li></ul> <hr> <h3 id="defaultcolwidth"><a href="#defaultcolwidth" class="header-anchor">#</a> defaultColWidth</h3> <ul><li>type：Number</li> <li>default：73</li> <li>usage： Customized default column width, unit is px</li></ul> <hr> <h3 id="celldata"><a href="#celldata" class="header-anchor">#</a> celldata</h3> <ul><li><p>type：Array</p></li> <li><p>default：[]</p></li> <li><p>usage： The original cell data set is a set containing <code>{r:0,c:0,v:{m:&quot;value&quot;,v:&quot;value&quot;,ct: {fa: &quot;General&quot;, t: &quot;g&quot;}} }</code>The one-dimensional array of format cell information is only used during initialization.</p> <p><code>r</code> represents the row, <code>c</code> represents the column, and <code>v</code> represents the value of the cell. value could be string, number, or object</p> <p>The luckysheet creates a sheet data based on the number of <code>options.data[i].row</code> and  <code>options.data[i].column</code>, then uses <code>data[r][c]=v</code> to fullfill tables. Empty data cells are represented as null.</p> <p>After initializing the table with celldata,the data is converted to the field <a href="#data">data</a>in the luckyshetfile such as <code>luckysheetfile[i].data</code>. <code>data</code> stores the following update data and celldata will no longer be used.</p></li> <li><p>example：</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span><span class="token punctuation">{</span>
    <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
    <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
    <span class="token string">&quot;v&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        m<span class="token operator">:</span><span class="token string">&quot;value1&quot;</span><span class="token punctuation">,</span>
        v<span class="token operator">:</span><span class="token string">&quot;value1&quot;</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
    <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
    <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
    <span class="token string">&quot;v&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        m<span class="token operator">:</span><span class="token string">&quot;value2&quot;</span><span class="token punctuation">,</span>
        v<span class="token operator">:</span><span class="token string">&quot;value2&quot;</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div></li></ul> <blockquote><p>more detail <a href="/LuckysheetDocs/zh/guide/cell.html">cell format</a></p></blockquote> <hr> <h3 id="config"><a href="#config" class="header-anchor">#</a> config</h3> <ul><li>type：Object</li> <li>default：{}</li> <li>usage：Table row height, column width, merged cells, borders, hidden rows and other settings
please be careful, config must be empty object <code>{}</code>, rather than empty string <code>&quot;&quot;</code> or <code>null</code></li></ul> <h4 id="config-merge"><a href="#config-merge" class="header-anchor">#</a> config.merge</h4> <ul><li>type：Object</li> <li>default：{}</li> <li>usage：Merge cell settings</li> <li>example：<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">{</span>
        <span class="token string">&quot;13_5&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">13</span><span class="token punctuation">,</span>
            <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rs&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
            <span class="token string">&quot;cs&quot;</span><span class="token operator">:</span> <span class="token number">1</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;13_7&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">13</span><span class="token punctuation">,</span>
            <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">7</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rs&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
            <span class="token string">&quot;cs&quot;</span><span class="token operator">:</span> <span class="token number">2</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;14_2&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">14</span><span class="token punctuation">,</span>
            <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rs&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
            <span class="token string">&quot;cs&quot;</span><span class="token operator">:</span> <span class="token number">2</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span>
</code></pre></div>The <code>key</code> in the object is the spliced value of <code>r +'_' + c</code>, and the <code>value</code> is the cell information in the upper left corner: r: number of rows, c: number of columns, rs: number of merged rows, cs: merge Number of columns</li></ul> <h4 id="config-rowlen"><a href="#config-rowlen" class="header-anchor">#</a> config.rowlen</h4> <ul><li>type：Object</li> <li>default：{}</li> <li>usage：The row height of each cell</li> <li>example：<div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;rowlen&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;0&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
            <span class="token string">&quot;1&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
            <span class="token string">&quot;2&quot;</span><span class="token operator">:</span> <span class="token number">20</span>
        <span class="token punctuation">}</span>
</code></pre></div></li></ul> <h4 id="config-columnlen"><a href="#config-columnlen" class="header-anchor">#</a> config.columnlen</h4> <ul><li>type：Object</li> <li>default：{}</li> <li>usage：The column width of each cell</li> <li>example：<div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;columnlen&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;0&quot;</span><span class="token operator">:</span> <span class="token number">97</span><span class="token punctuation">,</span>
            <span class="token string">&quot;1&quot;</span><span class="token operator">:</span> <span class="token number">115</span><span class="token punctuation">,</span>
            <span class="token string">&quot;2&quot;</span><span class="token operator">:</span> <span class="token number">128</span>
        <span class="token punctuation">}</span>
</code></pre></div></li></ul> <h4 id="config-rowhidden"><a href="#config-rowhidden" class="header-anchor">#</a> config.rowhidden</h4> <ul><li><p>type：Object</p></li> <li><p>default：{}</p></li> <li><p>usage：Hidden row information, Rows：<code>rowhidden[Rows]: 0</code>,</p> <p>you should specify the number of rows by <code>key</code>,<code>value</code> is always <code>0</code></p></li> <li><p>example：</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;rowhidden&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;30&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
            <span class="token string">&quot;31&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
        <span class="token punctuation">}</span>
</code></pre></div></li></ul> <h4 id="config-colhidden"><a href="#config-colhidden" class="header-anchor">#</a> config.colhidden</h4> <ul><li><p>type：Object</p></li> <li><p>default：{}</p></li> <li><p>usage：Hidden row information, Rows：<code>rowhidden[Rows]: 0</code>,
format：<code>colhidden[Cols]: 0</code>,</p> <div class="language- extra-class"><pre><code>  `key` specify the number of columns,`value` is always `0`
</code></pre></div></li> <li><p>example：</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;colhidden&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;30&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
            <span class="token string">&quot;31&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
        <span class="token punctuation">}</span>
</code></pre></div></li></ul> <h4 id="config-borderinfo"><a href="#config-borderinfo" class="header-anchor">#</a> config.borderInfo</h4> <ul><li><p>type：Array</p></li> <li><p>default：{}</p></li> <li><p>usage：The border information of the cell</p></li> <li><p>example：</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;borderInfo&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
        <span class="token string">&quot;rangeType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;cell&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;value&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;row_index&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
            <span class="token string">&quot;col_index&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
            <span class="token string">&quot;l&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token string">&quot;t&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token string">&quot;b&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;rangeType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;range&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;borderType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;border-all&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token string">&quot;3&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#0000ff&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;range&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
            <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">7</span><span class="token punctuation">,</span> <span class="token number">8</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
            <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">]</span>
        <span class="token punctuation">}</span><span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;rangeType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;range&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;borderType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;border-inside&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token string">&quot;3&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#0000ff&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;range&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
            <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">7</span><span class="token punctuation">,</span> <span class="token number">8</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
            <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">8</span><span class="token punctuation">,</span> <span class="token number">9</span><span class="token punctuation">]</span>
        <span class="token punctuation">}</span><span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div><p>The range type can be divided into single cell and selected area</p> <ol><li><p>selection <code>rangeType: &quot;range&quot;</code></p> <ul><li>Border type <code>borderType：&quot;border-left&quot; | &quot;border-right&quot; | &quot;border-top&quot; | &quot;border-bottom&quot; | &quot;border-all&quot; | &quot;border-outside&quot; | &quot;border-inside&quot; | &quot;border-horizontal&quot; | &quot;border-vertical&quot; | &quot;border-none&quot;</code>,</li> <li>Border thickness <code>style: 1 Thin | 2 Hair | 3 Dotted | 4 Dashed | 5 DashDot | 6 DashDotDot | 7 Double | 8 Medium | 9 MediumDashed | 10 MediumDashDot | 11 MediumDashDotDot | 12 SlantedDashDot | 13 Thick</code></li> <li>Border color <code>color: Hexadecimal color value</code></li> <li>Selection area <code>range: Row and column information array</code></li></ul></li> <li><p>Single cell <code>rangeType：&quot;cell&quot;</code></p> <ul><li>Number of rows and columns <code>value.row_index: number,value.col_index: number</code></li> <li>Four border objects <code>value.l:Left border,value.r:Right border,value.t:Top border,value.b:Bottom border</code></li> <li>Border thickness <code>value.l.style: 1 Thin | 2 Hair | 3 Dotted | 4 Dashed | 5 DashDot | 6 DashDotDot | 7 Double | 8 Medium | 9 MediumDashed | 10 MediumDashDot | 11 MediumDashDotDot | 12 SlantedDashDot | 13 Thick</code></li> <li>Border color <code>value.l.color: Hexadecimal color value</code></li></ul></li></ol> <p>templates：</p> <div class="language- extra-class"><pre><code>  + ```js
  {
      &quot;rangeType&quot;: &quot;range&quot;,
      &quot;borderType&quot;: &quot;border-all&quot;,
      &quot;style&quot;: &quot;3&quot;,
      &quot;color&quot;: &quot;#0000ff&quot;,
      &quot;range&quot;: [{
          &quot;row&quot;: [7, 8],
          &quot;column&quot;: [2, 3]
      }]
  }
  ```
  Represents a selection with a setting range of `{&quot;row&quot;: [7, 8], &quot;column&quot;: [2, 3]}`, the type is all borders, the border thickness is `Dotted`, and the color is `&quot;#0000ff&quot;`

  + ```js
      {
          &quot;rangeType&quot;: &quot;cell&quot;,
          &quot;value&quot;: {
              &quot;row_index&quot;: 3,
              &quot;col_index&quot;: 3,
              &quot;l&quot;: {
                  &quot;style&quot;: 10,
                  &quot;color&quot;: &quot;rgb(255, 0, 0)&quot;
              },
              &quot;r&quot;: {
                  &quot;style&quot;: 10,
                  &quot;color&quot;: &quot;rgb(255, 0, 0)&quot;
              },
              &quot;t&quot;: {
                  &quot;style&quot;: 10,
                  &quot;color&quot;: &quot;rgb(255, 0, 0)&quot;
              },
              &quot;b&quot;: {
                  &quot;style&quot;: 10,
                  &quot;color&quot;: &quot;rgb(255, 0, 0)&quot;
              }
          }
      }
      ```
   Means to set the cell `&quot;D4&quot;`, the upper border/lower border/left border/right border are all border thicknesses `&quot;MediumDashDot&quot;`, color is `&quot;rgb(255, 0, 0)&quot;`
</code></pre></div></li></ul> <h4 id="config-authority"><a href="#config-authority" class="header-anchor">#</a> config.authority</h4> <ul><li>type：Object</li> <li>default：{}</li> <li>usage：Worksheet protection, you can set that the entire worksheet is not allowed to be edited or some areas are not editable. If you want to apply for editing permission, you need to enter a password, and customize the types of operations that users can operate.</li> <li>example：<div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;authority&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token comment">//Permission configuration of the current worksheet</span>
    selectLockedCells<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Select locked cells</span>
    selectunLockedCells<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Select unlocked cells</span>
    formatCells<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Format cells</span>
    formatColumns<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Format columns</span>
    formatRows<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Format rows</span>
    insertColumns<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Insert columns</span>
    insertRows<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Insert rows</span>
    insertHyperlinks<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Insert hyperlinks</span>
    deleteColumns<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Delete columns</span>
    deleteRows<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Delete rows</span>
    sort<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Sort</span>
    filter<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Filter</span>
    usePivotTablereports<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Use Pivot Table reports</span>
    editObjects<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Edit objects</span>
    editScenarios<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Edit scenarios   </span>
    sheet<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//If it is 1 or true, the worksheet is protected; if it is 0 or false, the worksheet is not protected.</span>
    hintText<span class="token operator">:</span><span class="token string">&quot;&quot;</span><span class="token punctuation">,</span> <span class="token comment">//The text of the pop-up prompt</span>
    algorithmName<span class="token operator">:</span><span class="token string">&quot;None&quot;</span><span class="token punctuation">,</span><span class="token comment">//Encryption scheme: MD2,MD4,MD5,RIPEMD-128,RIPEMD-160,SHA-1,SHA-256,SHA-384,SHA-512,WHIRLPOOL</span>
    saltValue<span class="token operator">:</span><span class="token keyword">null</span><span class="token punctuation">,</span> <span class="token comment">//The salt parameter for password decryption is a random value set by yourself</span>
    
    allowRangeList<span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">{</span> <span class="token comment">//Range protection</span>
        name<span class="token operator">:</span><span class="token string">&quot;area&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Name</span>
        password<span class="token operator">:</span><span class="token string">&quot;1&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Password</span>
        hintText<span class="token operator">:</span><span class="token string">&quot;&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Prompt text</span>
        algorithmName<span class="token operator">:</span><span class="token string">&quot;None&quot;</span><span class="token punctuation">,</span><span class="token comment">//Encryption scheme: MD2,MD4,MD5,RIPEMD-128,RIPEMD-160,SHA-1,SHA-256,SHA-384,SHA-512,WHIRLPOOL</span>
        saltValue<span class="token operator">:</span><span class="token keyword">null</span><span class="token punctuation">,</span> <span class="token comment">//The salt parameter for password decryption is a random value set by yourself</span>
        sqref<span class="token operator">:</span><span class="token string">&quot;$C$1:$D$5&quot;</span> <span class="token comment">//Protected range</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span>
</code></pre></div></li></ul> <hr> <h3 id="scrollleft"><a href="#scrollleft" class="header-anchor">#</a> scrollLeft</h3> <ul><li>type：Number</li> <li>default：0</li> <li>usage： Left and right scroll bar position</li></ul> <hr> <h3 id="scrolltop"><a href="#scrolltop" class="header-anchor">#</a> scrollTop</h3> <ul><li>type：Number</li> <li>default：0</li> <li>usage： Up and down scroll bar position</li></ul> <hr> <h3 id="luckysheet-select-save"><a href="#luckysheet-select-save" class="header-anchor">#</a> luckysheet_select_save</h3> <ul><li>type：Array</li> <li>default：[]</li> <li>usage： The selected area supports multiple selections and is a one-dimensional array containing multiple selection objects.</li> <li>example：<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">1</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">0</span> <span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">4</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">3</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">3</span> <span class="token punctuation">]</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">]</span>
</code></pre></div></li></ul> <hr> <h3 id="calcchain"><a href="#calcchain" class="header-anchor">#</a> calcChain</h3> <ul><li>type：Array</li> <li>default：[]</li> <li>usage： Formula chain, used when the cell linked by the formula is changed, all formulas referencing this cell will be refreshed.</li> <li>example：<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span><span class="token punctuation">{</span>
    <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">6</span><span class="token punctuation">,</span> <span class="token comment">//the number of rows</span>
    <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token comment">//the number of columns</span>
    <span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//sheet id</span>
    <span class="token string">&quot;func&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token boolean">true</span><span class="token punctuation">,</span> <span class="token number">23.75</span><span class="token punctuation">,</span> <span class="token string">&quot;=AVERAGE(D3:D6)&quot;</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Formula information, including formula calculation results and formula string</span>
    <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;w&quot;</span><span class="token punctuation">,</span> <span class="token comment">//&quot;w&quot;：use Depth-First-Search &quot;b&quot;:Normal search</span>
    <span class="token string">&quot;parent&quot;</span><span class="token operator">:</span> <span class="token keyword">null</span><span class="token punctuation">,</span>
    <span class="token string">&quot;chidren&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;times&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
    <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">7</span><span class="token punctuation">,</span>
    <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
    <span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
    <span class="token string">&quot;func&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token boolean">true</span><span class="token punctuation">,</span> <span class="token number">30</span><span class="token punctuation">,</span> <span class="token string">&quot;=MAX(D3:D6)&quot;</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;w&quot;</span><span class="token punctuation">,</span>
    <span class="token string">&quot;parent&quot;</span><span class="token operator">:</span> <span class="token keyword">null</span><span class="token punctuation">,</span>
    <span class="token string">&quot;chidren&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;times&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
<span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div></li></ul> <hr> <h3 id="ispivottable"><a href="#ispivottable" class="header-anchor">#</a> isPivotTable</h3> <ul><li>type：Boolean</li> <li>default：false</li> <li>usage： is PivotTable</li></ul> <hr> <h3 id="pivottable"><a href="#pivottable" class="header-anchor">#</a> pivotTable</h3> <ul><li>type：Object</li> <li>default：{}</li> <li>usage： Pivot table settings</li> <li>example：<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">{</span>
    <span class="token string">&quot;pivot_select_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">12</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">4</span><span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;pivotDataSheetIndex&quot;</span><span class="token operator">:</span> <span class="token number">6</span><span class="token punctuation">,</span> <span class="token comment">//The sheet index where the source data is located</span>
    <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
        <span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
        <span class="token string">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;subject&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;fullname&quot;</span><span class="token operator">:</span> <span class="token string">&quot;subject&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
        <span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token string">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;student&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;fullname&quot;</span><span class="token operator">:</span> <span class="token string">&quot;student&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;filter&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;values&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
        <span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">4</span><span class="token punctuation">,</span>
        <span class="token string">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;score&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;fullname&quot;</span><span class="token operator">:</span> <span class="token string">&quot;count:score&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;sumtype&quot;</span><span class="token operator">:</span> <span class="token string">&quot;COUNTA&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;nameindex&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;showType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;column&quot;</span><span class="token punctuation">,</span>
    <span class="token string">&quot;pivotDatas&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token comment">//Source data for PivotTable</span>
        <span class="token punctuation">[</span><span class="token string">&quot;count:score&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;science&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;mathematics&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;foreign language&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;English&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;total&quot;</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token punctuation">[</span><span class="token string">&quot;Alex&quot;</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">4</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token punctuation">[</span><span class="token string">&quot;Joy&quot;</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">4</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token punctuation">[</span><span class="token string">&quot;Tim&quot;</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">4</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token punctuation">[</span><span class="token string">&quot;total&quot;</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">12</span><span class="token punctuation">]</span>
    <span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;drawPivotTable&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
    <span class="token string">&quot;pivotTableBoundary&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">5</span><span class="token punctuation">,</span> <span class="token number">6</span><span class="token punctuation">]</span>
<span class="token punctuation">}</span>
</code></pre></div></li></ul> <hr> <h3 id="filter-select"><a href="#filter-select" class="header-anchor">#</a> filter_select</h3> <ul><li>type：Object</li> <li>default：{}</li> <li>usage：Filter range. A selection and a sheet have only one filter range, similar to <code>luckysheet_select_save</code>. If you just create a selection to turn on the filter function, you can configure this range. If you need to set further detailed filter conditions, you need to configure the <a href="#filter">filter</a> property of the same level.</li> <li>example：<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">{</span>
    
    <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">6</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">3</span> <span class="token punctuation">]</span>
<span class="token punctuation">}</span>
</code></pre></div></li></ul> <hr> <h3 id="filter"><a href="#filter" class="header-anchor">#</a> filter</h3> <ul><li><p>type：Object</p></li> <li><p>default：{}</p></li> <li><p>usage：The specific settings of the filter match with the filter range of <code>filter_select</code>. When you create a filter area on the first sheet, you can also see the filter configuration information of the first sheet through <code>luckysheet.getLuckysheetfile()[0].filter</code>.</p> <p>The following is a complete filter configuration example</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">{</span>   
    <span class="token comment">//&quot;0&quot; means the first column</span>
    <span class="token string">&quot;0&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;caljs&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">// Filter by condition</span>
            <span class="token string">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;cellnull&quot;</span><span class="token punctuation">,</span> <span class="token comment">// Filter type</span>
            <span class="token string">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Is empty&quot;</span><span class="token punctuation">,</span> <span class="token comment">// Type description</span>
            <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span> <span class="token comment">// Filter categories</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;rowhidden&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token string">&quot;3&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token string">&quot;4&quot;</span><span class="token operator">:</span> <span class="token number">0</span> <span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">// Hidden row information</span>
        <span class="token string">&quot;optionstate&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span> <span class="token comment">// Whether to enable configuration</span>
        <span class="token string">&quot;cindex&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">// The current range column order, here is the first column</span>
        <span class="token string">&quot;str&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token comment">// Range, start row</span>
        <span class="token string">&quot;edr&quot;</span><span class="token operator">:</span> <span class="token number">6</span><span class="token punctuation">,</span> <span class="token comment">// Range, end row</span>
        <span class="token string">&quot;stc&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">// Range, start column</span>
        <span class="token string">&quot;edc&quot;</span><span class="token operator">:</span> <span class="token number">3</span> <span class="token comment">// Range, end column</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token comment">//&quot;1&quot; means the second column</span>
    <span class="token string">&quot;1&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;caljs&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;rowhidden&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token string">&quot;1&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;optionstate&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cindex&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token comment">// The current range column order, here is the second column</span>
        <span class="token string">&quot;str&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token string">&quot;edr&quot;</span><span class="token operator">:</span> <span class="token number">6</span><span class="token punctuation">,</span>
        <span class="token string">&quot;stc&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token string">&quot;edc&quot;</span><span class="token operator">:</span> <span class="token number">3</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre></div><ol><li>The <code>key</code> value of <code>filter[key]</code> means the column index, starting from 0, the <code>cindex</code> in the specific setting item starts from 1, which has the same meaning as the <code>key</code> here.</li> <li><code>caljs</code> is used to set the filter type and the corresponding value. After the setting takes effect, the hidden row information will be calculated and stored in <code>rowhidden</code>. The following are all the types that can be set, among which <code>value1</code> and <code>value2</code> are the text information filled in by the user:
<ul><li><code>caljs:{value: null, text: &quot;None&quot;, type: &quot;0&quot;}</code></li> <li><code>caljs:{value: &quot;cellnull&quot;, text: &quot;Is empty&quot;, type: &quot;0&quot;}</code></li> <li><code>caljs:{value: &quot;cellnonull&quot;, text: &quot;Is not empty&quot;, type: &quot;0&quot;}</code></li> <li><code>caljs:{value: &quot;textinclude&quot;, text: &quot;Text contains&quot;, type: &quot;1&quot;, value1: &quot;Lucky&quot;}</code></li> <li><code>caljs:{value: &quot;textnotinclude&quot;, text: &quot;Text does not contain&quot;, type: &quot;1&quot;, value1: &quot;Lucky&quot;}</code></li> <li><code>caljs:{value: &quot;textstart&quot;, text: &quot;Text starts with&quot;, type: &quot;1&quot;, value1: &quot;Lucky&quot;}</code></li> <li><code>caljs:{value: &quot;textend&quot;, text: &quot;Text ends with&quot;, type: &quot;1&quot;, value1: &quot;Lucky&quot;}</code></li> <li><code>caljs:{value: &quot;textequal&quot;, text: &quot;Text is exactly&quot;, type: &quot;1&quot;, value1: &quot;Lucky&quot;}</code></li> <li><code>caljs:{value: &quot;dateequal&quot;, text: &quot;Date is&quot;, type: &quot;1&quot;, value1: &quot;2020-10-16&quot;}</code></li> <li><code>caljs:{value: &quot;datelessthan&quot;, text: &quot;Date is before&quot;, type: &quot;1&quot;, value1: &quot;2020-10-16&quot;}</code></li> <li><code>caljs:{value: &quot;datemorethan&quot;, text: &quot;Date is after&quot;, type: &quot;1&quot;, value1: &quot;2020-10-16&quot;}</code></li> <li><code>caljs:{value: &quot;morethan&quot;, text: &quot;Greater than&quot;, type: &quot;1&quot;, value1: &quot;10&quot;}</code></li> <li><code>caljs:{value: &quot;moreequalthan&quot;, text: &quot;Greater than or equal to&quot;, type: &quot;1&quot;, value1: &quot;10&quot;}</code></li> <li><code>caljs:{value: &quot;lessthan&quot;, text: &quot;Less than&quot;, type: &quot;1&quot;, value1: &quot;10&quot;}</code></li> <li><code>caljs:{value: &quot;lessequalthan&quot;, text: &quot;Less than or equal to&quot;, type: &quot;1&quot;, value1: &quot;10&quot;}</code></li> <li><code>caljs:{value: &quot;equal&quot;, text: &quot;Is equal to&quot;, type: &quot;1&quot;, value1: &quot;10&quot;}</code></li> <li><code>caljs:{value: &quot;noequal&quot;, text: &quot;Is not equal to&quot;, type: &quot;1&quot;, value1: &quot;10&quot;}</code></li> <li><code>caljs:{value: &quot;include&quot;, text: &quot;Is between&quot;, type: &quot;2&quot;, value1: &quot;15&quot;, value2: &quot;25&quot;}</code></li> <li><code>caljs:{value: &quot;noinclude&quot;, text: &quot;Is not between&quot;, type: &quot;2&quot;, value1: &quot;15&quot;, value2: &quot;25&quot;}</code></li></ul></li> <li><code>rowhidden</code> is stored hidden row information, but if <code>caljs</code> is not set to filter by conditions, it means that color filtering (if there is a color distinction between the rows) and filtering by value are set. So it can be seen that the priority of <code>caljs</code> is greater than that of <code>rowhidden</code>.</li> <li><code>optionstate</code> indicates whether to enable the configuration, this is an internal flag, just set <code>true</code> directly.</li> <li><code>cindex</code> represents the column order currently set, counting from 1 and corresponding to the <code>key</code> value of <code>filter[key]</code>, and the result is <code>key</code>+1.</li> <li><code>str</code> is the start row, <code>edr</code> is the end row, <code>stc</code> is the start column, and <code>edc</code> is the end column. The four numbers represent the entire filter range, which should be consistent with the content of <code>filter_select</code>.</li></ol></li></ul> <hr> <h3 id="luckysheet-alternateformat-save"><a href="#luckysheet-alternateformat-save" class="header-anchor">#</a> luckysheet_alternateformat_save</h3> <ul><li>type：Array</li> <li>default：[]</li> <li>usage： Alternating color configuration</li> <li>example：<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span><span class="token punctuation">{</span>
    <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//cell range</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">6</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">5</span><span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;head&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//Header color</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#5ed593&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;one&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//The first color</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ffffff&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;two&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//The second color</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#e5fbee&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;foot&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//Footers color</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#a5efcc&quot;</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;hasRowHeader&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span> <span class="token comment">//is included header</span>
    <span class="token string">&quot;hasRowFooter&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span> <span class="token comment">//is included footer</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
    <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">6</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">8</span><span class="token punctuation">,</span> <span class="token number">12</span><span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;head&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#5599fc&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;one&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ffffff&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;two&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ecf2fe&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;foot&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#afcbfa&quot;</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;hasRowHeader&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
    <span class="token string">&quot;hasRowFooter&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span>
<span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div></li></ul> <hr> <h3 id="luckysheet-alternateformat-save-modelcustom"><a href="#luckysheet-alternateformat-save-modelcustom" class="header-anchor">#</a> luckysheet_alternateformat_save_modelCustom</h3> <ul><li>type：Array</li> <li>default：[]</li> <li>usage：Custom alternate colors, including multiple custom alternate colors configuration</li> <li>example：<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span><span class="token punctuation">{</span>
    <span class="token string">&quot;head&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//Header color</span>
        <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#6aa84f&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ffffff&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;one&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//The first color</span>
        <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ffffff&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;two&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//The second color</span>
        <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#e5fbee&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;foot&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//The footer color</span>
        <span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#a5efcc&quot;</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div></li></ul> <hr> <h3 id="luckysheet-conditionformat-save"><a href="#luckysheet-conditionformat-save" class="header-anchor">#</a> luckysheet_conditionformat_save</h3> <ul><li><p>type：Array</p></li> <li><p>default：[]</p></li> <li><p>usage： Conditional format configuration information, a one-dimensional array containing multiple conditional format configuration objects,</p> <p>type: &quot;default&quot;: Highlight cell rules and project selection rules,</p> <p>&quot;dataBar&quot;:Data bar,</p> <p>&quot;icons&quot;:Icon set,</p> <p>&quot;colorGradation&quot;: Color scale</p> <p>You can get more detail in this API page<a href="/LuckysheetDocs/zh/guide/api.html">API setRangeConditionalFormat</a></p></li> <li><p>example：</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;default&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token comment">//cell range</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">7</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token comment">//when type is default, you should set the text color and cell color </span>
            <span class="token string">&quot;textColor&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;cellColor&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ff0000&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;conditionName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;betweenness&quot;</span><span class="token punctuation">,</span> <span class="token comment">//type</span>
        <span class="token string">&quot;conditionRange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token comment">//condition value in the cell </span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">4</span><span class="token punctuation">,</span> <span class="token number">4</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">6</span><span class="token punctuation">,</span> <span class="token number">6</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;conditionValue&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">4</span>
        <span class="token punctuation">]</span> <span class="token comment">//Customize the condition value</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;dataBar&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">10</span><span class="token punctuation">,</span> <span class="token number">15</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">10</span><span class="token punctuation">,</span> <span class="token number">11</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token string">&quot;#6aa84f&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;#ffffff&quot;</span>
        <span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;icons&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">19</span><span class="token punctuation">,</span> <span class="token number">23</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;len&quot;</span><span class="token operator">:</span> <span class="token string">&quot;3&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;leftMin&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;top&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;colorGradation&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">10</span><span class="token punctuation">,</span> <span class="token number">15</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">6</span><span class="token punctuation">,</span> <span class="token number">6</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token string">&quot;rgb(99, 190, 123)&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rgb(255, 235, 132)&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rgb(248, 105, 107)&quot;</span>
        <span class="token punctuation">]</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">]</span>
</code></pre></div></li></ul> <hr> <h3 id="frozen"><a href="#frozen" class="header-anchor">#</a> frozen</h3> <ul><li><p>type：Array</p></li> <li><p>default：[]</p></li> <li><p>usage： the settings of freeze row and column which is divided into 6 types</p> <ol><li>&quot;row&quot;: the first freeze row</li> <li>&quot;column&quot;: the first freeze column</li> <li>&quot;both&quot;: the freeze rows and columns</li> <li>&quot;rangeRow&quot;: Freeze row to range</li> <li>&quot;rangeColumn&quot;: Freeze column to range</li> <li>&quot;rangeBoth&quot;: Freeze column and row to range</li> <li>&quot;cancel&quot;: cancel freeze</li></ol> <p>When setting the freezing to the selected area, you need to set the cell position to turn on the freezing. The format should like this<code>{ row_focus:0, column_focus:0 }</code>，which mean the rows and cols of an active cell.</p> <p>The new configuration property of sheet, which stores more semantic configuration, is used to initialize and pass to the server.</p> <p>Be careful, you can find <code>freezenhorizontaldata</code> in the luckysheetfile that used for freezen, however <code>freezenhorizontaldata</code> is only for local debugging。</p></li> <li><p>example：</p> <ul><li>Freeze first line</li></ul> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
    type<span class="token operator">:</span> 'row'
<span class="token punctuation">}</span>
</code></pre></div><ul><li>Freeze row and column to <code>'A1'</code></li></ul> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
   type<span class="token operator">:</span> 'rangeRow'<span class="token punctuation">,</span>
   range<span class="token operator">:</span> <span class="token punctuation">{</span>row_focus<span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> column_focus<span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre></div><ul><li>Freeze row and column to <code>'B2'</code></li></ul> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
   type<span class="token operator">:</span> 'rangeBoth'<span class="token punctuation">,</span>
   range<span class="token operator">:</span> <span class="token punctuation">{</span>row_focus<span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> column_focus<span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre></div></li></ul> <hr> <h3 id="chart"><a href="#chart" class="header-anchor">#</a> chart</h3> <ul><li>type：Array</li> <li>default：[]</li> <li>usage： Chart configuration, plz refer to chartMix configuration. Allows you to set only the desired chart properties.</li> <li>example：<details class="custom-block details"><summary>DETAILS</summary> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
    <span class="token property">&quot;chart_id&quot;</span><span class="token operator">:</span> <span class="token string">&quot;chart_p145W6i73otw_1596209943446&quot;</span><span class="token punctuation">,</span>
    <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">400</span><span class="token punctuation">,</span>
    <span class="token property">&quot;height&quot;</span><span class="token operator">:</span> <span class="token number">250</span><span class="token punctuation">,</span>
    <span class="token property">&quot;left&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
    <span class="token property">&quot;top&quot;</span><span class="token operator">:</span> <span class="token number">120</span><span class="token punctuation">,</span>
    <span class="token property">&quot;sheetIndex&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sheet_6az6nei65t1i_1596209937084&quot;</span><span class="token punctuation">,</span>
    <span class="token property">&quot;needRangeShow&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
    <span class="token property">&quot;chartOptions&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token property">&quot;chart_id&quot;</span><span class="token operator">:</span> <span class="token string">&quot;chart_p145W6i73otw_1596209943446&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;chartAllType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;echarts|line|default&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;rangeArray&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token punctuation">{</span> <span class="token property">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">4</span> <span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token property">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">7</span> <span class="token punctuation">]</span> <span class="token punctuation">}</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token property">&quot;rangeColCheck&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token property">&quot;exits&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span> <span class="token property">&quot;range&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">0</span> <span class="token punctuation">]</span> <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token property">&quot;rangeRowCheck&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span> <span class="token property">&quot;exits&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span> <span class="token property">&quot;range&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">0</span> <span class="token punctuation">]</span> <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token property">&quot;rangeConfigCheck&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
        <span class="token property">&quot;defaultOption&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token property">&quot;title&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                <span class="token property">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;default title&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;left-top&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;offsetX&quot;</span><span class="token operator">:</span> <span class="token number">40</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;offsetY&quot;</span><span class="token operator">:</span> <span class="token number">50</span>
                <span class="token punctuation">}</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token property">&quot;subtitle&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                <span class="token property">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;distance&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusGap&quot;</span><span class="token operator">:</span> <span class="token number">40</span>
                <span class="token punctuation">}</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;transparent&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sans-serif&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;grid&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;normal&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;top&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;left&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;right&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;bottom&quot;</span><span class="token operator">:</span> <span class="token number">10</span>
                <span class="token punctuation">}</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token property">&quot;legend&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                <span class="token property">&quot;selectMode&quot;</span><span class="token operator">:</span> <span class="token string">&quot;multiple&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;selected&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
                    <span class="token punctuation">{</span>
                        <span class="token property">&quot;seriesName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;衣服&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;isShow&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token punctuation">{</span>
                        <span class="token property">&quot;seriesName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;食材&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;isShow&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token punctuation">{</span>
                        <span class="token property">&quot;seriesName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;图书&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;isShow&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;left-top&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;offsetX&quot;</span><span class="token operator">:</span> <span class="token number">40</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;offsetY&quot;</span><span class="token operator">:</span> <span class="token number">50</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;direction&quot;</span><span class="token operator">:</span> <span class="token string">&quot;horizontal&quot;</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusSize&quot;</span><span class="token operator">:</span> <span class="token number">25</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;height&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusSize&quot;</span><span class="token operator">:</span> <span class="token number">14</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;distance&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusGap&quot;</span><span class="token operator">:</span> <span class="token number">10</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;itemGap&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token property">&quot;data&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
                    <span class="token string">&quot;Mon&quot;</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;Tues&quot;</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;Wed&quot;</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;Thur&quot;</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;Fri&quot;</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;Sat&quot;</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;Sun&quot;</span>
                <span class="token punctuation">]</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token property">&quot;tooltip&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;backgroundColor&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgba(50,50,50,0.7)&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;triggerOn&quot;</span><span class="token operator">:</span> <span class="token string">&quot;mousemove&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;triggerType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;item&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;axisPointer&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;line&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;style&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#555&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token string">&quot;normal&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;solid&quot;</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
                    <span class="token punctuation">{</span>
                        <span class="token property">&quot;seriesName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;衣服&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token punctuation">{</span>
                        <span class="token property">&quot;seriesName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;食材&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token punctuation">{</span>
                        <span class="token property">&quot;seriesName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;图书&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token property">&quot;axis&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token property">&quot;axisType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;xAxisDown&quot;</span><span class="token punctuation">,</span>
                <span class="token property">&quot;xAxisUp&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;title&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;showTitle&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;nameGap&quot;</span><span class="token operator">:</span> <span class="token number">15</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;fzPosition&quot;</span><span class="token operator">:</span> <span class="token string">&quot;end&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;显示X轴&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;inverse&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tick&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token string">&quot;outside&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;length&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLabel&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;optimize&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;distance&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;min&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;max&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;solid&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netArea&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorOne&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorTwo&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;axisLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;onZero&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;xAxisDown&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;title&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;showTitle&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;nameGap&quot;</span><span class="token operator">:</span> <span class="token number">15</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;fzPosition&quot;</span><span class="token operator">:</span> <span class="token string">&quot;end&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;显示X轴&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;inverse&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tick&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token string">&quot;outside&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;length&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLabel&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;optimize&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;distance&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;min&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;max&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;solid&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netArea&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorOne&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorTwo&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;data&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
                        <span class="token string">&quot;BUS&quot;</span><span class="token punctuation">,</span>
                        <span class="token string">&quot;UBER&quot;</span><span class="token punctuation">,</span>
                        <span class="token string">&quot;TAXI&quot;</span><span class="token punctuation">,</span>
                        <span class="token string">&quot;SUBWAY&quot;</span>
                    <span class="token punctuation">]</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;category&quot;</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;yAxisLeft&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;title&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;showTitle&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;nameGap&quot;</span><span class="token operator">:</span> <span class="token number">15</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;fzPosition&quot;</span><span class="token operator">:</span> <span class="token string">&quot;end&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;显示Y轴&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;inverse&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tick&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token string">&quot;outside&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;length&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLabel&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;formatter&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;split&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;min&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;max&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;distance&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;solid&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netArea&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorOne&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorTwo&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;value&quot;</span>
                <span class="token punctuation">}</span><span class="token punctuation">,</span>
                <span class="token property">&quot;yAxisRight&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;title&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;showTitle&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;text&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;nameGap&quot;</span><span class="token operator">:</span> <span class="token number">15</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;fzPosition&quot;</span><span class="token operator">:</span> <span class="token string">&quot;end&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;显示Y轴&quot;</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;inverse&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tick&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;position&quot;</span><span class="token operator">:</span> <span class="token string">&quot;outside&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;length&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;tickLabel&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;label&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;fontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#333&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontFamily&quot;</span><span class="token operator">:</span> <span class="token string">&quot;sans-serif&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;fontGroup&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusFontSize&quot;</span><span class="token operator">:</span> <span class="token number">12</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;rotate&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;formatter&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;split&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;min&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;max&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;prefix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;suffix&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;ratio&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;digit&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;distance&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netLine&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;solid&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token property">&quot;netArea&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token property">&quot;show&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;interval&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                            <span class="token property">&quot;value&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                            <span class="token property">&quot;cusNumber&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
                        <span class="token punctuation">}</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorOne&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span><span class="token punctuation">,</span>
                        <span class="token property">&quot;colorTwo&quot;</span><span class="token operator">:</span> <span class="token string">&quot;auto&quot;</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">}</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token property">&quot;isShow&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span>
<span class="token punctuation">}</span>
</code></pre></div><p>:::</p></details></li></ul> <hr> <h3 id="zoomratio"><a href="#zoomratio" class="header-anchor">#</a> zoomRatio</h3> <ul><li>type：Number</li> <li>default：1</li> <li>usage： the zoom ratio of a sheet, which is a two decimal digit between 0~1, like <code>0.1</code>、<code>0.56</code>.</li></ul> <hr> <h3 id="image"><a href="#image" class="header-anchor">#</a> image</h3> <ul><li>type：Array</li> <li>default：[]</li> <li>usage： Insert the picture information in the table, including picture address, width and height, position, cropping and other information</li> <li>example：
The following is an example of <code>imageItem</code>, usually there may be multiple images in a worksheet, so the format of <code>image</code> is array <code>[imageItem,imageItem,...]</code><div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
    type<span class="token operator">:</span> '<span class="token number">3</span>'<span class="token punctuation">,</span> <span class="token comment">//1 Move and resize the cell 2 Move and do not resize the cell 3 Don't move and resize the cell</span>
    src<span class="token operator">:</span>''<span class="token punctuation">,</span> <span class="token comment">//image url</span>
    originWidth<span class="token operator">:</span> <span class="token number">1484</span><span class="token punctuation">,</span> <span class="token comment">//The original width of the picture</span>
    originHeight<span class="token operator">:</span> <span class="token number">834</span><span class="token punctuation">,</span> <span class="token comment">//The original height of the picture</span>
    default<span class="token operator">:</span> <span class="token punctuation">{</span>
        width<span class="token operator">:</span> <span class="token number">293</span><span class="token punctuation">,</span> <span class="token comment">//image width</span>
        height<span class="token operator">:</span> <span class="token number">196</span><span class="token punctuation">,</span> <span class="token comment">//image height</span>
        left<span class="token operator">:</span> <span class="token number">409</span><span class="token punctuation">,</span> <span class="token comment">//The position of the picture from the left of the table</span>
        top<span class="token operator">:</span> <span class="token number">248</span><span class="token punctuation">,</span> <span class="token comment">//The position of the picture from the top of the table</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    crop<span class="token operator">:</span> <span class="token punctuation">{</span>
        width<span class="token operator">:</span> <span class="token number">293</span><span class="token punctuation">,</span> <span class="token comment">//The width of the picture after cropping</span>
        height<span class="token operator">:</span> <span class="token number">196</span><span class="token punctuation">,</span> <span class="token comment">//The height of the picture after cropping</span>
        offsetLeft<span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//Displacement from the left of the picture after cropping</span>
        offsetTop<span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//Displacement from the left of the picture after cropping</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    isFixedPos<span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span> <span class="token comment">//Fixed position</span>
    fixedLeft<span class="token operator">:</span> <span class="token number">507</span><span class="token punctuation">,</span> <span class="token comment">//Fixed position left displacement</span>
    fixedTop<span class="token operator">:</span> <span class="token number">141</span><span class="token punctuation">,</span> <span class="token comment">//fixed position right displacement</span>
    border<span class="token operator">:</span> <span class="token punctuation">{</span>
        width<span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//border width</span>
        radius<span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//Border radius</span>
        style<span class="token operator">:</span>'solid'<span class="token punctuation">,</span> <span class="token comment">//border type</span>
        color<span class="token operator">:</span>'#<span class="token number">000</span>'<span class="token punctuation">,</span> <span class="token comment">//Border color</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre></div></li></ul> <hr> <h3 id="showgridlines"><a href="#showgridlines" class="header-anchor">#</a> showGridLines</h3> <ul><li>Type: Number</li> <li>Default: 1</li> <li>Usage: Whether to show grid lines, <code>1</code> means show, <code>0</code> means hidden</li></ul> <hr> <h2 id="debug-information"><a href="#debug-information" class="header-anchor">#</a> debug information</h2> <p>The parameters required for initialization will be designed as simple as possible, but the parameters stored locally are different.</p> <p>After initialization, Luckysheet stores more and more local data in luckysheetfile as local parameter. It means that we can realize the usage of Store data center. For example, the format of Freezen's parameters will also change.</p> <p>At this point, the lucky sheet file contains many local parameters that are not initialized and can be used to debug、analysis local status. you can use  <code>luckysheet.getluckysheetfile()</code> to get more information：</p> <details class="custom-block details"><summary>DETAILS</summary> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">[</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Cell&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet name</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet color</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet index</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet active status</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//The order of the worksheet</span>
        <span class="token property">&quot;hide&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span><span class="token comment">//Whether worksheet hide </span>
        <span class="token property">&quot;row&quot;</span><span class="token operator">:</span> <span class="token number">36</span><span class="token punctuation">,</span> <span class="token comment">//The number of rows in a sheet</span>
        <span class="token property">&quot;column&quot;</span><span class="token operator">:</span> <span class="token number">18</span><span class="token punctuation">,</span> <span class="token comment">//The number of columns in a sheet</span>
        <span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Initial the cell data</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token property">&quot;merge&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Merged cells</span>
            <span class="token property">&quot;rowlen&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Table row height</span>
            <span class="token property">&quot;columnlen&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Table column width</span>
            <span class="token property">&quot;rowhidden&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Hidden rows</span>
            <span class="token property">&quot;colhidden&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Hidden columns</span>
            <span class="token property">&quot;borderInfo&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Borders</span>
            <span class="token property">&quot;authority&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet protection</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token property">&quot;scrollLeft&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//Left and right scroll bar position</span>
        <span class="token property">&quot;scrollTop&quot;</span><span class="token operator">:</span> <span class="token number">315</span><span class="token punctuation">,</span> <span class="token comment">//Up and down scroll bar position</span>
        <span class="token property">&quot;luckysheet_select_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Selected area</span>
        <span class="token property">&quot;calcChain&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span><span class="token comment">//Formula chain</span>
        <span class="token property">&quot;isPivotTable&quot;</span><span class="token operator">:</span><span class="token boolean">false</span><span class="token punctuation">,</span><span class="token comment">//Whether is pivot table</span>
        <span class="token property">&quot;pivotTable&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//Pivot table settings</span>
        <span class="token property">&quot;filter_select&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//Filter range</span>
        <span class="token property">&quot;filter&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span><span class="token comment">//Filter configuration</span>
        <span class="token property">&quot;luckysheet_alternateformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Alternate colors</span>
        <span class="token property">&quot;luckysheet_alternateformat_save_modelCustom&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Customize alternate colors	</span>
        <span class="token property">&quot;luckysheet_conditionformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//Condition format</span>
        <span class="token property">&quot;frozen&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Freeze row and column configuration</span>
        <span class="token property">&quot;freezen&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Storage freeze row and column rendering data</span>
        <span class="token property">&quot;chart&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Chart configuration</span>
        <span class="token property">&quot;zoomRatio&quot;</span><span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">// Zoom ratio</span>
        <span class="token property">&quot;image&quot;</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//image</span>
        <span class="token property">&quot;showGridLines&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token comment">//Whether to show grid lines</span>
        

        <span class="token property">&quot;visibledatarow&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Positions of all rows</span>
        <span class="token property">&quot;visibledatacolumn&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Positions of all columns</span>
        <span class="token property">&quot;ch_width&quot;</span><span class="token operator">:</span> <span class="token number">2322</span><span class="token punctuation">,</span> <span class="token comment">//The width of a sheet</span>
        <span class="token property">&quot;rh_height&quot;</span><span class="token operator">:</span> <span class="token number">949</span><span class="token punctuation">,</span> <span class="token comment">//The heighSt of a sheet</span>
        <span class="token property">&quot;load&quot;</span><span class="token operator">:</span> <span class="token string">&quot;1&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Check whether this sheed has been loaded</span>
        <span class="token property">&quot;data&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">// Store and update the cell data</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sheet2&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sheet3&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">]</span>
</code></pre></div></details> <h3 id="visibledatarow"><a href="#visibledatarow" class="header-anchor">#</a> visibledatarow</h3> <ul><li>type：Number</li> <li>default：[]</li> <li>usage： Position information of all rows, incremental row position data, No need to set up for initialization</li></ul> <hr> <h3 id="visibledatacolumn"><a href="#visibledatacolumn" class="header-anchor">#</a> visibledatacolumn</h3> <ul><li>type：Number</li> <li>default：[]</li> <li>usage： Position information of all columns, incremental column position data, No need to set up for initialization</li></ul> <hr> <h3 id="ch-width"><a href="#ch-width" class="header-anchor">#</a> ch_width</h3> <ul><li>type：Number</li> <li>default：2322</li> <li>usage： The width of the entire worksheet area (the gray area including the border), No need to set up for initialization</li></ul> <hr> <h3 id="rh-height"><a href="#rh-height" class="header-anchor">#</a> rh_height</h3> <ul><li>type：Number</li> <li>default：2322</li> <li>usage： The height of the entire worksheet area (the gray area containing the border), No need to set up for initialization</li></ul> <hr> <h3 id="load"><a href="#load" class="header-anchor">#</a> load</h3> <ul><li>type：Number</li> <li>default：0</li> <li>usage： Check whether the current sheet has been loaded, internal indicator, initialization does not need to be set</li></ul> <hr> <h3 id="data"><a href="#data" class="header-anchor">#</a> data</h3> <ul><li>type：Array</li> <li>default：[]</li> <li>usage： conveted from celldata in initialization stage. <code>data</code> will have the update operation data.Initialization does not need to be set</li> <li>example：
Here is a two row, two column data<div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">[</span>
    <span class="token punctuation">[</span><span class="token punctuation">{</span>
        ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        m<span class="token operator">:</span><span class="token string">&quot;value1&quot;</span><span class="token punctuation">,</span>
        v<span class="token operator">:</span><span class="token string">&quot;value1&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
        ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        m<span class="token operator">:</span><span class="token string">&quot;value2&quot;</span><span class="token punctuation">,</span>
        v<span class="token operator">:</span><span class="token string">&quot;value2&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token punctuation">[</span><span class="token punctuation">{</span>
        ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        m<span class="token operator">:</span><span class="token string">&quot;value3&quot;</span><span class="token punctuation">,</span>
        v<span class="token operator">:</span><span class="token string">&quot;value3&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
        ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        m<span class="token operator">:</span><span class="token string">&quot;value4&quot;</span><span class="token punctuation">,</span>
        v<span class="token operator">:</span><span class="token string">&quot;value4&quot;</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span>
<span class="token punctuation">]</span>

</code></pre></div></li></ul> <hr></div> <footer class="page-edit"><div class="edit-link"><a href="https://github.com/mengshukeji/Luckysheet/edit/master/docs/guide/sheet.md" target="_blank" rel="noopener noreferrer">Edit this page on GitHub</a> <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></div> <div class="last-updated"><span class="prefix">Last Updated:</span> <span class="time">12/17/2020, 8:23:07 AM</span></div></footer> <div class="page-nav"><p class="inner"><span class="prev">
      ←
      <a href="/LuckysheetDocs/guide/config.html" class="prev">
        Overall configuration
      </a></span> <span class="next"><a href="/LuckysheetDocs/guide/cell.html">
        Format attributes
      </a>
      →
    </span></p></div> </main></div><div class="global-ui"></div></div>
    <script src="/LuckysheetDocs/assets/js/app.fd749708.js" defer></script><script src="/LuckysheetDocs/assets/js/2.08ae9631.js" defer></script><script src="/LuckysheetDocs/assets/js/20.085877c0.js" defer></script>
  </body>
</html>
